package com.yfeng.quartz.job;

import java.util.List;

import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import com.yfeng.common.dao.impl.BaseDaoImpl;
import com.yfeng.common.utils.BeanUtil;

public class CacheJob implements Job{

	@Override
	public void execute(JobExecutionContext arg0) throws JobExecutionException {
		
		BaseDaoImpl dao = (BaseDaoImpl)BeanUtil.getBean("BaseDaoImpl");
		try {
			List resultList = dao.query("select t.buytotalprice,t.id,t2.id as uid,t2.point from mystocks t,users t2 where t.uid=t2.id and TO_DAYS(NOW()) - TO_DAYS(t.lrrq) >=1 and t.gyf='0' and t.isdel=0");
		
		
		
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

}
